<?php
echo ('
<h1>Добавить город</h1>
<form name="" action="" method="post">
	<input name="table" type="text" value=""><input type="submit" value="Send" name="makeCity">
</form>
');
include('../class/class_connect.php');
$table=$_POST['table'];
/*
$aConnect=new connect('m');
$query="CREATE TABLE ".$table." (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
rating VARCHAR(255) NOT NULL,
votes VARCHAR(255) NOT NULL,
user VARCHAR(255) NOT NULL,
name VARCHAR(255) NOT NULL,
short VARCHAR(255) NOT NULL,
link VARCHAR(255) NOT NULL,
address VARCHAR(255) NOT NULL,
phone VARCHAR(255) NOT NULL,
workdays VARCHAR(255) NOT NULL,
text_title VARCHAR(255) NOT NULL,
stext TEXT NOT NULL,
firms TEXT NOT NULL,
status VARCHAR(255) NOT NULL,
data DATETIME NOT NULL
);";
mysql_query($query);
mysql_close();
$aConnect=new connect("cs");
$query="
CREATE TABLE ".$table." (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
street VARCHAR(255) NOT NULL,
buildings TEXT NOT NULL
);";
mysql_query($query);
mysql_close();
*/
$aConnect=new connect("mc");
$query="
CREATE TABLE ".$table." (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
m_id INT(11) NOT NULL,
user_name VARCHAR(255) NOT NULL,
user_status VARCHAR(255) NOT NULL,
stext TEXT NOT NULL,
data DATETIME NOT NULL
);";
mysql_query($query);
mysql_close();
$aConnect=new connect("fc");
$query="
CREATE TABLE ".$table." (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
m_id INT(11) NOT NULL,
user_name VARCHAR(255) NOT NULL,
user_status VARCHAR(255) NOT NULL,
stext TEXT NOT NULL,
data DATETIME NOT NULL
);";
mysql_query($query);
mysql_close();
$aConnect=new connect("mr");
$query="
CREATE TABLE ".$table." (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
firm_id INT(11) NOT NULL,
rating FLOAT NOT NULL,
votes id INT(11) NOT NULL,
user VARCHAR(255) NOT NULL,
data DATETIME NOT NULL
);";
mysql_query($query);
mysql_close();
$aConnect=new connect("fr");
$query="
CREATE TABLE ".$table." (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
firm_id INT(11) NOT NULL,
rating FLOAT NOT NULL,
votes id INT(11) NOT NULL,
user VARCHAR(255) NOT NULL,
data DATETIME NOT NULL
);";
mysql_query($query);
mysql_close();


?>